<?php
/**
 *  Copyright (c) 2014, dsphinx@plug.gr
 *  All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *   1. Redistributions of source code must retain the above copyright
 *      notice, this list of conditions and the following disclaimer.
 *   2. Redistributions in binary form must reproduce the above copyright
 *      notice, this list of conditions and the following disclaimer in the
 *      documentation and/or other materials provided with the distribution.
 *   3. All advertising materials mentioning features or use of this software
 *      must display the following acknowledgement:
 *      This product includes software developed by the dsphinx.
 *   4. Neither the name of the dsphinx nor the
 *      names of its contributors may be used to endorse or promote products
 *     derived from this software without specific prior written permission.
 *
 *  THIS SOFTWARE IS PROVIDED BY dsphinx ''AS IS'' AND ANY
 *  EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
 *  WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
 *  DISCLAIMED. IN NO EVENT SHALL dsphinx BE LIABLE FOR ANY
 *  DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
 *  (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
 *  LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
 *  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 *  (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 *  SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *  
 *  
 */

    $sql = 'SELECT field_data.* FROM field_data WHERE id=?';
    $rec = $db->rawQuery($sql, array($_id));
    $t   = $rec[0];

    $id    = $t['id'];
    $title = isset($t['var44']) ? $t['var44'] : "χωρίς τίτλο";


    $user = $t['auth_id'] ? Auth::get_info_guest($t['auth_id'], "email") : ' Αγνωστος ';

    $img     = $t['var54'] ? '<img src="data:image/jpeg;base64,' . base64_encode($t['var54']) . ' " />' : '<img src="Media/images/no_image.png"  />';
    $keimeno = isset($t['var45']) ? $t['var45'] : "χωρίς κείμενο";
    $price   = $t['var12'];
    $url = $_SERVER['REQUEST_URI']."&rm=1";

    $txt_client = " <br/> Ημερομηνία :  <small>" . $t['date_update'] . "</small>";

    echo '
<div class="clearfix"></div> <br/>
<div>
    <div class="results_lines" style="width:93%;">
        <div class="results_lines_img"  style="padding: 10px 10px 10px 0px;"> ' . $img . '</div>
        <div class="results_lines_title alert alert-info" style="min-width: 900px">' . $title . ' </div>
        <br/><br/>
        <div class="results_lines_text"> ' . $keimeno . ' </div>
        <div class="results_lines_bottom">' . $price . ' </div>
        <div class="clearfix"> </div>
    </div>

</div>

        <div class=""  style="padding: 10px 10px 10px 60px;"> ' . $txt_client . ' </div>
        <br/>
        <a class="btn btn-info btn-small" href="'.$url.'"> Διαγραφή </a>
                <hr />

';